<%@ page contentType="text/html;charset=gbk" %>
<%@ page import="com.oa.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.oa.database.*"%>


<%
    String id = request.getParameter("id");
    ConvertChinese convertChinese = new ConvertChinese();
    id = convertChinese.toChinese(id);
    if (id.equals("")) {
      id = "0";
    }

    String  sTable = "OA_XMMB";
    String  sField = "MBNR";
    String  sCond = "MBID="+id;
    DataConn dataConn = new DataConn();
    QueryData queryData = new QueryData(dataConn);
    queryData.setMultRecordSet(sTable, sField, sCond);
    ResultSet rs_template = queryData.getResultSet();
    String content = "";

    try {
        if (rs_template.next()) {
            content = rs_template.getString("MBNR");
        }
    }
    catch(Exception e) {}

    out.println(content);
%>
